Logging on to MS SQL Server via ODBC

This section is intended as an example of how to log on to a Microsoft SQL Server^TM data source from Seagate Crystal Reports. Your SQL server application or any other password-protected data source may require different steps.

To log on to MS SQL Server via ODBC

1. Verify the settings for the Microsoft SQL Server data source using ODBC Administrator. See Checking settings for an ODBC data source.
2. From Seagate Crystal Reports, choose Log On/Off Server from the Database menu.

   The Data Explorer dialog box appears.

   

3. Choose a SQL Server data source and then click Log On.

   The SQL Server Login dialog box appears.

   

4. Type your MS SQL Server login ID and password.
5. Click Options.

   The Options section of the SQL Server Login dialog box appears.

   

6. Verify the settings for your SQL Server.
7. Verify the name of the SQL Server database you want to open, the database language you want to use, the name of the application you are using (Seagate Crystal Reports), and the name of your computer workstation. Make any changes necessary.
8. Click OK.